commlog destination in Solaris

--_004_8585BA53443004458E0BAA6134C5A7FB47CA5CDDEGEXCMB01owwr oo_
Content-Type: multipart/alternative;
boundary="_000_8585BA53443004458E0BAA6134C5A7FB47CA5CDDEGEXC MB01owwroo_"

--_000_8585BA53443004458E0BAA6134C5A7FB47CA5CDDEGEXCMB01owwr oo_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,
We're having problems with connection failures from Informatica to GP/PG. =
there's nothing in the GP/PG log.
We've turned on the commlog trace in the odbc settings.
Can someone tell me where I can find the log location?
We're running PsqlODBC 8.0.4 on solaris 10 sparc 64bit.

Our odbc.ini file
[GreenplumProd_Write]
Driver=3D/infa/GreenPlum/greenplum-connectivity/drivers/odbc /psqlodbc-08.02=
..0500/datadirect-52_32/psqlodbcw.so
#Driver=3D/infa/GreenPlum/connectivity-3.2-build-9981/driver s/odbc/psqlodbc=
-08.03.0400/unixodbc-2.2.12/psqlodbcw.so
#Driver=3D/infa/GreenPlum/connectivity-3.2-build-9981/psqlod bcw.so
Description=3DGreenplum Production - Read_Write
Servername=3Deggpdbvip.prod.orbitz.net
Port=3D5432
Database=3Dp1gp1
Username=3Dinfa_write
Password=3Dinfagpwrite
UseDeclareFetch=3D0
Fetch=3D20000
Protocol=3D7.4-1
Trace=3D0
Debug=3D0
Readonly=3DNo

Add
COMMLOG=3D1

Thanks


Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwid=
e
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312=
..894.5164 | Cell 847-997-5741
Douglas.Little@orbitz.com
[cid:image001.jpg@01CB9106.F2E81B40] orbitz.com =
| ebookers.com | hotelclub.com ub.com/> | cheaptickets.com | ratestogo.com ttp://www.ratestogo.com/> | asiahotels.com


--_000_8585BA53443004458E0BAA6134C5A7FB47CA5CDDEGEXCMB01owwr oo_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"
" xmlns=3D"http://www.w3.org/TR/REC-html40"> V=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii"> enerator content=3D"Microsoft Word 12 (filtered medium)"> nk=3Dpurple>